home *** CD-ROM | disk | FTP | other *** search
/ Power Tools for Macintosh / Power Tools for Macintosh (SoftBit)(1992).iso / Business / FileMaker Templates / AdMaster 2.0 / Sales.FM (.txt) < prev    next >
FileMaker Pro Database  |  1993-06-18  |  146KB  |  1,798 lines

  1. Kneeds@
  2. 342-4838@
  3. Women's@
  4. KneeonsG
  5. Jeepers@
  6. BILL COMMENTS DATES
  7. COMMISSION RATE
  8. NEXT BILL DUE BY
  9. PRODUCTION CHARGE LU
  10. SALESPERSON INITIALS CALC
  11. HBAM2001MAY84
  12. Sales.FM:*
  13. Casting
  14. Chariots
  15. Clinic
  16. Films
  17. Grace's
  18. Happiness
  19. Hollywood
  20. Kneeons
  21. Knighted
  22. Lawrence
  23. Lemons
  24. Lotsa
  25. Pantinene
  26. Pasta
  27. Restaurante
  28. Spot/doty
  29. Stone
  30. Vales
  31. Video
  32. Women's
  33. Bleed
  34. Color
  35. Eighth
  36. Horiz
  37. Non-bleed
  38. Quarter
  39. Advertising
  40. Casting
  41. Clothing
  42. Lighting
  43. Medical
  44. Recreation
  45. Restaurant
  46. Sales
  47. Allison
  48. Allison
  49. Dayna
  50. Frank
  51. Jeepers
  52. Jerry
  53. Jones
  54. Longe
  55. Sally
  56. Smith
  57. Smothers
  58. 45634
  59. 67455
  60. Avenue
  61. Canon
  62. Drive
  63. Hillhurst
  64. Melrose
  65. Monica
  66. Santa
  67. Street
  68. Suite
  69. Sunset
  70. Varna
  71. Wilshire
  72. Angeles
  73. Beverly
  74. Burbank
  75. Hills
  76. Hills
  77. Hollywood
  78. North
  79. 10022
  80. 90024
  81. 90027
  82. 90028
  83. 90038
  84. 90048
  85. 90210
  86. 91502
  87. 91605
  88. Andrea
  89. Harry
  90. Patty
  91. Stephen
  92. Advertising
  93. Attire
  94. Creative
  95. Entertainment
  96. Fashion
  97. Fruit
  98. Gardening
  99. Health
  100. Movies
  101. Repair
  102. Restaurant
  103. Supplies
  104. Video
  105. Women
  106. Approved
  107. Camera
  108. Cancelled
  109. Problem
  110. Produced
  111. Proof
  112. Ready
  113. Received
  114. Requested
  115. Print
  116. Two-pay
  117. Visa/mc
  118. Agency
  119. Joe's
  120. Ultimate
  121. 010231
  122. 123941
  123. 90016
  124. Helterberg
  125. Rocky
  126. 323-2342
  127. 662-1233
  128. Johnny
  129. Smith
  130. Tommy
  131. Agency
  132. Barter
  133. Angela
  134. Approved
  135. Change
  136. Charge
  137. Incorrect
  138. Number
  139. Phone
  140. Production
  141. Proof
  142. Verbal
  143. Waive
  144. Jones
  145. Kneeds
  146. Simmons
  147. Smith
  148. Smothers
  149. Thomas
  150. Andrea
  151. Harry
  152. Jones
  153. Kneeds
  154. Patty
  155. Simmons
  156. Smith
  157. Smothers
  158. Stephen
  159. Thomas
  160. 342-4838
  161. 453-1554
  162. 467-3000
  163. 471-2879
  164. 473-2181
  165. 508-2134
  166. 564-3592
  167. 643-0458
  168. 643-3247
  169. 658-8866
  170. 685-1108
  171. 743-3000
  172. 754-9890
  173. 213-3435
  174. 437-0893
  175. 574-9542
  176. 685-1108
  177. Spoke
  178. Lemons
  179. Trade
  180. Contract
  181. Received
  182. Casting
  183. Chariots
  184. Clinic
  185. Films
  186. Grace's
  187. Happiness
  188. Hollywood
  189. Kneeons
  190. Knighted
  191. Lawrence
  192. Lemons
  193. Lotsa
  194. Pantinene
  195. Pasta
  196. Restaurante
  197. Spot/doty
  198. Stone
  199. Vales
  200. Video
  201. Women's
  202. Discount
  203. Agent
  204. Chiropactor
  205. Manager
  206. Owner
  207. President
  208. Allison
  209. Dayna
  210. Frank
  211. Jeepers
  212. Jerry
  213. Jones
  214. Longe
  215. Sally
  216. Smith
  217. Smothers
  218. Allison
  219. Dayna
  220. Frank
  221. Jones
  222. Longe
  223. Smothers
  224. Automotive
  225. Business
  226. Entertainment
  227. Medical
  228. Personal
  229. Advertising
  230. Business
  231. Entertainment
  232. Fashion
  233. Health
  234. Recreation
  235. Restauarant
  236. Attire
  237. Creative
  238. Entertainment
  239. Health
  240. Movies
  241. Repair
  242. Restaurant
  243. Video
  244. Casting
  245. Chariots
  246. Clinic
  247. Films
  248. Grace's
  249. Happiness
  250. Hollywood
  251. Kneeons
  252. Kneeons
  253. Knighted
  254. Lawrence
  255. Lemons
  256. Lotsa
  257. Pantinene
  258. Pasta
  259. Restaurante
  260. Spot/doty
  261. Stone
  262. Vales
  263. Video
  264. Women's
  265. Bottom
  266. Center
  267. Column
  268. Facing
  269. Furniture
  270. Kneeons
  271. Knighted
  272. Right
  273. Section
  274. Upper
  275. Allison
  276. Dayna
  277. Frank
  278. Jeepers
  279. Jerry
  280. Jones
  281. Longe
  282. Sally
  283. Smith
  284. Smothers
  285. Allison
  286. Dayna
  287. Frank
  288. Jones
  289. Longe
  290. Smothers
  291. Pro 2.0F!
  292. Pro 2.0I
  293. Main Dictionary
  294. 6/17/93
  295.     AD NUMBER
  296. ADDITIONAL LISTINGS ACTUAL
  297. ADDITIONAL LISTINGS DESIRED
  298. ADDRESS
  299. AGENCY ADDRESS
  300. AGENCY CONTACT
  301. AGENCY GROSS COST
  302. AGENCY NAME
  303. AGENCY NET COST
  304. AGENCY PHONE
  305. BALANCE OUTSTANDING
  306. BALANCE OUTSTANDING TOTAL
  307. BILL COMMENTS
  308. NENCY GROSS COST
  309. AGENCY NAME
  310. AGENCY NET COST
  311. AGENCY PHONE
  312. BALANCE OUTSTANDING
  313. BALANCE OUTSTANDING TOTAL
  314. BILL COMMENTS
  315. BILL COMMENTS DATES
  316. BILL SIZE DEFAULT
  317. BONUS EARNED
  318. BONUS EARNED 2ND SP
  319. BONUS EARNED TOTAL
  320. BOOK ID
  321. CATEGORY ACTUAL
  322. CATEGORY DESIRED
  323. COMMENT FOR BILL
  324. COMMISSION ACTUAL
  325. COMMISSION ACTUAL 2ND SP
  326. COMMISSION ACTUAL 2ND SP SUM
  327. COMMISSION ACTUAL SUM
  328. COMMISSION ADJUSTMENT
  329. COMMISSION ADJUSTMENT 2ND SP
  330. COMMISSION POTENTIAL
  331. COMMISSION POTENTIAL 2ND SP
  332. !COMMISSION POTENTIAL 2NS SP TOTAL
  333. COMMISSION POTENTIAL TOTAL
  334. COMMISSION RATE
  335. COMMISSION RATE 2ND SP
  336. COMPANY
  337. COMPANY COUNT
  338. COMPANY DISPLAY
  339. COMPANY LU
  340. COMPENSATION TOT
  341. COMPENSATION TOT TOTAL
  342. COMPENSATION TOTAL
  343. COMPENSATION TOTAL TOTAL
  344. CONTACT FIRST
  345. CONTACT FULL
  346. CONTACT LAST
  347. CONTACT TITLE
  348. CONTRACT STATUS
  349. a    DATE SOLD
  350. DATE SOLD FIRST
  351. DATE SOLD LAST
  352. DISCOUNT FLAG
  353. DISCOUNT TYPE
  354. DUE DATE CALC
  355. LAST BILL AMT
  356. LAST BILL DUE BY
  357. LAST SENT ON
  358. NEXT BILL AMOUNT
  359. NEXT BILL DUE BY
  360. NUMBER OF COLORS
  361. OTHER DISCOUNT
  362. OTHER DISCOUNT COMMENT
  363. PAID LAST BILL
  364. PAID PERCENT OF SALE
  365. PAID PERCENT OF SALE TOTAL
  366. PAYMENT PLAN
  367. PAYMENT RCVD DATE LAST
  368. PAYMENTS RCVD TOTAL
  369. PAYMENTS RCVD TOTAL TOTAL
  370. PAYMENTS RECEIVED
  371. PAYMENTS RECEIVED CHECK NO
  372. PAYMENTS RECEIVED DATES
  373. PHONE
  374. PLACEMENT DESIRED
  375. PLACEMENT PAGE NUM
  376. PRODUCTION BEGAN
  377. PRODUCTION CHARGE ACTUAL
  378. PRODUCTION CHARGE ACTUAL TOTAL
  379. PRODUCTION CHARGE LU
  380. PRODUCTION COST
  381. PRODUCTION COST TOTAL
  382. PRODUCTION LOSS
  383. PRODUCTION LOSS TOTAL
  384. PRODUCTION NOTES
  385. PRODUCTION NOTES DATE
  386. PRODUCTION STATUS
  387. PROFIT
  388. PROFIT PERC OF SALE
  389. PROFIT PERC OF SALE TOTAL
  390. PROFIT TOTAL
  391. REBILLED ON
  392. RECEIVED TO DATE
  393. RECEIVED TO DATE TOTAL
  394. RETURN MATERIALS
  395. SALEPERSON #
  396. SALESPERSON
  397. SALESPERSON # 2ND SP
  398. SALESPERSON 2ND SP
  399. SALESPERSON DISPLAY
  400. SALESPERSON DISPLAY 2ND SP
  401. SALESPERSON INITIALS CALC
  402. SALESPERSON LU
  403. SALESPERSON LU 2ND SP
  404. SECTION
  405. SIZE NUMBER
  406. SIZE NUMBER TOTAL
  407. SPACE CHARGE
  408. SPACE CHARGE CALC
  409. SPACE CHARGE COUNT
  410. SPACE CHARGE LOOKUP
  411. SPACE CHARGE RCVD TOTAL
  412. SPACE CHG RCVD
  413. SPACE CHG RCVD COUNT
  414. SPACE CREDIT
  415. SPACE CREDIT TOTAL
  416. SPACE OUTSTANDING
  417. STATE
  418. SUBTOTAL
  419. SUBTOTAL COUNT
  420. TAB DISPLAY
  421. TOTAL DISCOUNT
  422. TOTAL DISCOUNT TOTAL
  423. TOTAL SALE
  424. TOTAL SALE COUNT
  425. Company LUB
  426. A    Ad NumberB
  427. A    Date SoldB
  428. SizeB
  429. Tab (bleed)
  430. Tab (non-bleed)
  431. Full page color
  432. Full page B&W
  433. Half page (vert)
  434. Half page (horiz)
  435. Quarter page (vert)
  436. Quarter page (horiz)
  437. Eighth page
  438. Category DesiredB
  439. (none)
  440. Space ChargeB
  441. WIF 93sK
  442. can't find
  443. Production Charge ActualB
  444. ChargesnK
  445. can't findM
  446. Total SaleB
  447. SubTotal - Total Discount
  448. SalespersonB
  449. Salespeople.FM
  450. AddressB
  451. Leads.FMt
  452. CityB
  453. Leads.FMt
  454. StateB
  455. Leads.FMt
  456. Leads.FMt
  457. Contact FirstB
  458. Leads.FMt
  459. Additional Listings DesiredB
  460. Number of Colors
  461. 1 spot
  462. 2 spot
  463. Four Color
  464. Production StatusB
  465. No Input
  466. Camera Ready - not received
  467. Camera Ready - received - OK
  468. Camera Ready - received - Problem
  469. Camera Ready - approved
  470. To be Produced - not received
  471. To be Produced - received - OK
  472. To be Produced - rece
  473. ived - Problem
  474. To be Produced - in production
  475. To be Produced - out to proof
  476. To be Produced - approved
  477. Old Ad - requested - OK
  478. Old Ad - requested - Problem
  479. Old Ad - approved
  480. On Hold
  481. Cancelled              C
  482. No Input
  483. Payment PlanB
  484. Two-Pay
  485. Visa/MC
  486. Agency NameB
  487. Agency AddressB
  488. Agency PhoneB
  489. Agency ContactB
  490. Agency Gross CostB
  491. Agency Net CostB
  492. discount typeB
  493. 5% Full
  494. 15% Agency
  495. Barter
  496. Production notesB
  497. Production notes dateB
  498. SubTotalB
  499. A'Space Charge + Production Charge Actual
  500. Other DiscountB
  501. Total DiscountB
  502. ((Space Charge*((If (Position (discount type,"5% Full", 1), .05, 0)+If (Position (discount type,"15% Agency", 1), .15, 0)))+Other Discount))
  503. 5% Full
  504. 15% Agency
  505. 333333
  506. Contact LastB
  507. Leads.FMtK
  508. can't find
  509. Balance OutstandingB
  510. Total Sale-Received to Date
  511. Payments ReceivedB
  512. Payments Received DatesB
  513. Received to DateB
  514. Sum (Payments Received)
  515. Comment for BillB
  516. Charges
  517. can't find
  518. Next Bill AmountB
  519. WIF 93sK
  520. can't find
  521. Next Bill due byB
  522. WIF 93sK
  523. can't find
  524. contact fullB
  525. Leads.FMtK
  526. can't find
  527. phoneB
  528. Leads.FMtK
  529. can't find
  530. Leads.FMtK
  531. can't find
  532. Bill CommentsB
  533. Bill comments datesB
  534. Bill Size DefaultB
  535. AxIf (Payment Plan = "Two-Pay" and Balance Outstanding 
  536. ( .6 * Total Sale), .5 * Balance Outstanding, Balance Outstanding)
  537. Two-Pay
  538. 333333
  539. Last Bill amtB
  540. Last Sent onB
  541. Rebilled onB
  542. Last Bill Due ByB
  543. Other Discount CommentB
  544. Due Date CalcB
  545. Tody+30
  546. Contract StatusB
  547. Rcvd Contract
  548. Not Received
  549. Not Received
  550. CompanyB
  551. Leads.FM K
  552. Something's Wrong
  553. Discount FlagB
  554. A#IF (total discount>0,"Discount","")
  555. Discount'
  556. Contact TitleB
  557. Leads.FMtK
  558. can't find
  559. Space Charge CalcB
  560. Space Charge Lookup
  561. Space Charge LookupB
  562. Charges.FM<K
  563. can't find
  564. Company CountB
  565. Return materialsB
  566. Production CostB
  567. Production BeganB
  568. Payments Received Check NoB
  569. Space Charge CountB
  570. Size NumberB
  571. Charges.FM<K
  572. can't find
  573. Size Number TOTALB
  574. Space Chg RcvdB
  575. A?IF(Received to Date<Space Credit,Received to Date,Space Credit)
  576. Bonus EarnedB
  577. 12.50
  578. 51.50
  579. Bonus Earned TOTALB
  580. Total Discount TOTALB
  581. Space Charge Rcvd TOTALB
  582. Commission RateB
  583. commission adjustmentB
  584. Commission actualB
  585. A9Commission Rate *( Space Chg Rcvd)+ commission adjustment
  586. commission actual SUMB
  587. Space CreditB
  588. A?IF(Space Charge-Total Discount>0,Space Charge-Total Discount,0)
  589. space Credit TotalB
  590. Balance Outstanding TOTALB
  591. Production Cost TOTALB
  592. production lossB
  593. A*Production Cost - Production Charge Actual
  594. Production loss TOTALB
  595. production charge actual TOTALB
  596. Book IDB
  597.     A,PAR 92
  598. PAR 93
  599. WIF 93
  600. PAR 94
  601. SONY 94
  602. CBS 94
  603. Fall '93
  604. Production Charge LUB
  605. Charges.FM<K
  606. can't find
  607. Salesperson Initials CalcB
  608. APLeft (Salesperson, 1) & Middle (Salesperson,1+
  609. Position (Salesperson, " ", 2),1)
  610. Commission PotentialB
  611. A-(Space Credit-Space Chg Rcvd)*Commission Rate
  612. commission potential TOTALB
  613. SubTotal CountB
  614. received to date TOTALB
  615. Total Sale CountB
  616. Space Chg Rcvd CountB
  617. Salesperson LUB
  618. Leads.FM
  619. can't find
  620. Salesperson 2nd SPB
  621. Salespeople.FM
  622. can't find
  623. Commission Rate 2nd SPB
  624. commission actual 2nd SPB
  625. AF(Commission Rate 2nd SP * Space Chg Rcvd)+Commission adjustment 2nd SP
  626. commission actual 2nd SP SUMB
  627. :(_N^Nu
  628. Salesperson LU 2nd SPB
  629. Paid percent of saleB
  630. AYIF ((Space Charge-Total Discount)>0,(Compensation total)/(Space Charge-Total Discount),0)
  631. paid percent of sale TOTALB
  632. Date Sold FirstB
  633. Date Sold LastB
  634. SectionB
  635. Saleperson #B
  636. Salespeople.FM
  637. AllisonE
  638. HillsC
  639. 323-2342@
  640. Kneeds@
  641. 342-4838@
  642. Women's@
  643. KneeonsG
  644. Jeepers@
  645. BILL COMMENTS DATES
  646. COMMISSION RATE
  647. NEXT BILL DUE BY
  648. PRODUCTION CHARGE LU
  649. SALESPERSON INITIALS CALC
  650. Commission adjustment 2nd SPB
  651. SALESPERSON # 2nd SPB
  652. Salespeople.FM
  653. TAB displayB
  654. A IF (Left(size,3)="Tab","Tab","")
  655. Compensation totalB
  656. A Commission actual + Bonus Earned
  657. Compensation total TOTALB
  658. Category actualB
  659. Additional Listings ActualB
  660. Company DisplayB
  661. Company
  662. Bonus Earned 2nd SPB
  663. Commission Potential 2nd SPB
  664. A4(Space Credit-Space Chg Rcvd)*Commission Rate 2nd SP
  665. Space OutstandingB
  666. AD(IF ((Space Chg Rcvd<Space Credit),Space Credit - Space Chg Rcvd,0))
  667. Placement DesiredB
  668. Salesperson DisplayB
  669. Salesperson
  670. Placement Page numB
  671. Salesperson Display 2ND SPB
  672. Salesperson 2nd SP
  673. Paid last billB
  674. A#Payment Rcvd Date last>Last Sent on
  675. Payment Rcvd Date lastB
  676. last(Payments Received Dates)
  677. TodyB
  678. A!commission potential 2ns sp TOTALB
  679. Payments Rcvd TotalB
  680. Sum (Payments Received)
  681. Compensation totB
  682. AKCommission actual+commission actual 2nd SP+Bonus Earned+Bonus Earned 2nd SP
  683. ProfitB
  684. A4Payments Rcvd Total-Production Cost-Compensation tot
  685. Profit Perc of SaleB
  686. Profit/Payments Rcvd Total
  687. Payments Rcvd Total TOTALB
  688. Compensation tot TOTALB
  689. Profit TOTALB
  690. Profit Perc of Sale TOTALB
  691. Sold By Company
  692. Sold By Salesperson
  693. Sold By desired cat
  694. Production Overview
  695. Production Detail
  696. Accounts Summary
  697. A    Statement
  698. A#Master Sales Splits For Salespeople
  699. Categories Actual
  700. Sales
  701. Agency
  702. Billing
  703. Commission
  704. Production
  705. Rebill Statement
  706. Sold By actual cat
  707. A    Placement
  708. Sold By Salesperson
  709. Mailing Labels
  710. Production Problems
  711. Categories Desired
  712. OVERDUE ACCOUNTS
  713. A    Need Bill
  714. Comm stmt Sold 
  715. Comm stmt split Sold 
  716. A    Ad Profit
  717. Sold By CompanyB
  718. YesfH
  719. Company
  720. Sold ads as of //
  721. page ##
  722.  ads sold.
  723. Salesperson
  724. E    Date Sold
  725. Sales
  726. Sold By Salesperson
  727. YesfH
  728. Company
  729. Sold ads as of //
  730. page ##
  731. has sold
  732. Sales for 
  733.  ads.
  734. contact 
  735. phone
  736. Sold By desired cat
  737. YesfH
  738. Company
  739. E%Sold ads by Desired Category as of //
  740. E'Sold WIF by category as of // 
  741.  page ##
  742. E     ads for 
  743. Salesperson
  744. Desired Category: 
  745. E    Date Sold
  746. Production OverviewB
  747. YesfH
  748. YesfH
  749. Company 
  750. Production Status
  751. Production Overview as of //
  752. Prod.
  753. Began
  754. E    Prod
  755. ads listed.
  756. Charge
  757. Sales
  758. Production
  759. Production Detail
  760. YesfH
  761. YesfH
  762. YesfH
  763. Company
  764. E$Production Report as of // by Status
  765. Prod Began
  766. Total Ads:
  767. E    Prod Cost
  768. Prod.
  769. Charge
  770. Salesperson
  771. Accounts SummaryB
  772. YesfH
  773. YesfH
  774. YesfH
  775. YesfH
  776. Company
  777. contact name
  778. Total Sale
  779. Balance 
  780. Outst
  781. OUSTANDING ACCOUNTS AS OF //
  782. Balance Outstanding Total
  783. phone
  784. Sales
  785. ads listed.
  786. Last Bill Sent
  787. Last pymt Rcvd
  788. 'A    StatementB
  789. YesfH
  790. YesfH
  791. YesfH
  792. YesfH
  793. YesfH
  794. YesfH
  795. YesfH
  796. YesfH
  797. A<Statement of Account
  798.  for Advertisement in 1994 Master Guide
  799. Contract #:
  800. Salesperson:
  801. Size:
  802. Payment Plan:
  803. Amount Due Now
  804. Comments
  805. Due By
  806. E3Thank you for your support of the 1994 Master Guide
  807. Bill To:
  808. Statement Date:
  809. Current Charges
  810. Ad Info:
  811. Received
  812. Total Sale
  813. Production
  814. Space
  815. Balance
  816. Outstanding
  817. AWPlease remit to:
  818. Praxis Computing
  819. 1911 Camino Costa 
  820. Suite #415
  821. Redondo Beach, CA 90277
  822. .A#Master Sales Splits For SalespeopleB
  823. YesfH
  824. YesfH
  825. YesfH
  826. YesfH
  827. YesfH
  828. YesfH
  829. YesfH
  830. YesfH
  831. YesfH
  832. YesfH
  833. YesfH
  834. YesfH
  835. YesfH
  836. YesfH
  837. YesfH
  838. YesfH
  839. YesfH
  840. YesfH
  841. YesfH
  842. E    Date
  843. Company
  844. Prod/
  845. Color
  846. E    Comission
  847. Net Sale
  848. Discount
  849. Split Sales, //
  850. Advertiser
  851. Totals    
  852. Outstanding
  853. Space$
  854. Net Sale
  855. Space Paid
  856. E    Comm
  857. // - ##
  858. Categories ActualB
  859. Company
  860. Section
  861. Category Actual
  862. Additional Listings
  863. E%Sections & Actual Categories as of //
  864. Sales
  865. E    Placement
  866. SalesB
  867. YesfH
  868. YesfH
  869. YesfH
  870. YesfH
  871. YesfH
  872. YesfH
  873. YesfH
  874. Desired
  875. Category
  876. Desired
  877. Additional
  878. Listings
  879. Colors
  880. Production
  881. Status
  882. SaleS
  883. Company
  884. Contract
  885. Production
  886. Space
  887. SubTotal
  888. Total Sale
  889. Total Discount
  890. Payment
  891. Other Discount
  892. Charges
  893. Payment Plan
  894. E    Date Sold
  895. Address
  896. Contact
  897. phone
  898. AD Info
  899. E    Discounts
  900. Amount
  901. Description
  902. Agency
  903. Salesperson
  904. Defaults
  905. Billing
  906. Commission
  907. Production
  908. E    Placement
  909. command
  910. center
  911. AgencyB
  912. Agency Name
  913. Address
  914. Phone
  915. Contact
  916. Agency
  917. Sales
  918. BillingB
  919. YesfH
  920. YesfH
  921. YesfH
  922. YesfH
  923. YesfH
  924. YesfH
  925. YesfH
  926. YesfH
  927. Total Sale
  928. Outstanding
  929. Payment Plan
  930. Received to Date
  931. Payment
  932. bill for
  933. due by
  934. Due by
  935. E    Next Bill
  936. Comment
  937. for Bill
  938. Check #
  939. Advertiser Payments
  940. Company
  941. BILLING
  942. E    LAST BILL
  943. Rebilled
  944. COMMENTS
  945. Defaults
  946. E    Send Bill
  947. Rebill
  948. Sales
  949. Comment
  950. E    Date Sold
  951. CommissionB
  952. YesfH
  953. YesfH
  954. YesfH
  955. YesfH
  956. YesfH
  957. YesfH
  958. YesfH
  959. YesfH
  960. YesfH
  961. YesfH
  962. YesfH
  963. YesfH
  964. YesfH
  965. YesfH
  966. YesfH
  967. Space Credit
  968. Space Paid
  969. Salesperson #1
  970. Company
  971. ComMission
  972. Salesperson
  973. Bonus
  974. Commission
  975. Adjustment
  976. Commission
  977. Salesperson #2
  978. Salesperson
  979. Bonus
  980. Commission
  981. Adjustment
  982. Commission
  983. Add. Comm.
  984. on full collection
  985. Add. Comm.
  986. on full collection
  987. Space Charge
  988. Total Discount
  989. Space
  990. Outstanding
  991. Sales
  992. ProductionB
  993. YesfH
  994. YesfH
  995. YesfH
  996. Production Detail
  997. Colors
  998. Production Notes
  999. Return
  1000. materials?
  1001. Production
  1002. Production
  1003. Began
  1004. Production
  1005. Production Status
  1006. Desired
  1007. Category
  1008. Desired
  1009. Additional
  1010. Listings
  1011. Company
  1012. Desired
  1013. Placement
  1014. Production
  1015. Charge
  1016. Salesperson
  1017. Sales
  1018. Rebill StatementB
  1019. YesfH
  1020. YesfH
  1021. YesfH
  1022. YesfH
  1023. YesfH
  1024. YesfH
  1025. YesfH
  1026. YesfH
  1027. A<Statement of Account
  1028.  for Advertisement in 1994 Master Guide
  1029. Contract #:
  1030. Salesperson:
  1031. Size:
  1032. Payment Plan:
  1033. Amount Due Now
  1034. Comments
  1035. Due By
  1036. E3Thank you for your support of the 1994 Master Guide
  1037. Bill To:
  1038. Statement Date:
  1039. Current Charges
  1040. Ad Info:
  1041. Received
  1042. Total Sale
  1043. Production
  1044. Space
  1045. Balance
  1046. Outstanding
  1047. AWPlease remit to:
  1048. Praxis Computing
  1049. 1911 Camino Costa 
  1050. Suite #415
  1051. Redondo Beach, CA 90277
  1052. SECOND NOTICE
  1053. Sold By actual cat
  1054. YesfH
  1055. Company
  1056. E$Sold ads by Actual Category as of //
  1057. page ##
  1058. E     ads for 
  1059. Salesperson
  1060. Desired Category: 
  1061. E    Date Sold
  1062. Category Desired
  1063. BA    PlacementB
  1064. YesfH
  1065. Production Detail
  1066. Colors
  1067. E    PLACEMENT
  1068. Desired
  1069. Category
  1070. Desired
  1071. Additional
  1072. Listings
  1073. Company
  1074. Desired
  1075. Placement
  1076. Salesperson
  1077. Sales
  1078. Actual
  1079. Category
  1080. Actual
  1081. Additional
  1082. Listings
  1083. Actual
  1084. Page #
  1085. Section
  1086. Sold By SalespersonB
  1087. YesfH
  1088. Company
  1089. Sold ads as of //
  1090. page ##
  1091.  ads sold.
  1092. Salesperson
  1093. E    Date Sold
  1094. Sales
  1095. Mailing LabelsB
  1096. Sales
  1097. Production ProblemsB
  1098. YesfH
  1099. Company 
  1100. Production Status
  1101. Production Problems as of //
  1102. Prod.
  1103. Began
  1104. E    Prod Cost
  1105. ads listed.
  1106. Prod.
  1107. Charge
  1108. Sales
  1109. Production
  1110. Categories DesiredB
  1111. Company
  1112. Category Desired
  1113. Actual Additional Listings
  1114. E&Sections & Desired Categories as of //
  1115. Sales
  1116. Category Actual
  1117. E    Placement
  1118. OVERDUE ACCOUNTSB
  1119. YesfH
  1120. YesfH
  1121. YesfH
  1122. YesfH
  1123. YesfH
  1124. Company
  1125. contact name
  1126. Total Sale
  1127. Balance 
  1128. Outst
  1129. OVERDUE ACCOUNTS AS OF //
  1130. Balance Outstanding Total
  1131. phone
  1132. Sales
  1133. ads listed.
  1134. Last bill amount
  1135. Due by
  1136. Rebilled
  1137. Rebill All
  1138. HA    Need BillB
  1139. YesfH
  1140. YesfH
  1141. YesfH
  1142. YesfH
  1143. Company
  1144. contact name
  1145. Total Sale
  1146. Balance 
  1147. Outst
  1148. ACCOUNTS NEEDING BILLS AS OF //
  1149. Balance Outstanding Total
  1150. phone
  1151. Sales
  1152. ads listed.
  1153. Last Bill Sent
  1154. Last pymt Rcvd
  1155. Bill All
  1156. Comm stmt Sold 
  1157. YesfH
  1158. YesfH
  1159. YesfH
  1160. YesfH
  1161. YesfH
  1162. YesfH
  1163. YesfH
  1164. YesfH
  1165. YesfH
  1166. YesfH
  1167. YesfH
  1168. YesfH
  1169. YesfH
  1170. YesfH
  1171. YesfH
  1172. YesfH
  1173. Company
  1174. Ads for Comission as of //
  1175. page ##
  1176. has sold
  1177. Sales for 
  1178.  ads.
  1179. Discount
  1180. Space
  1181. Space
  1182. Credit
  1183. Space Chg
  1184. Comm 
  1185. Comm 
  1186. Actual
  1187. Add. comm on full Collect.
  1188. TOTAL
  1189. Comm stmt split Sold 
  1190. YesfH
  1191. YesfH
  1192. YesfH
  1193. YesfH
  1194. YesfH
  1195. YesfH
  1196. YesfH
  1197. YesfH
  1198. YesfH
  1199. YesfH
  1200. YesfH
  1201. YesfH
  1202. YesfH
  1203. YesfH
  1204. YesfH
  1205. YesfH
  1206. YesfH
  1207. YesfH
  1208. YesfH
  1209. YesfH
  1210. YesfH
  1211. Company
  1212. E Split Ads for Comission as of //
  1213. page ##
  1214. E    has split
  1215. Sales for 
  1216.  ads.
  1217. E    Comission
  1218. Discount
  1219. Advertiser
  1220. Outstanding
  1221. Space
  1222. Space Paid
  1223. E    Comm
  1224. Space
  1225. Credit
  1226. Space Chg
  1227. Comm 
  1228. Comm 
  1229. Actual
  1230. Add. comm on full Collect.
  1231. TOTAL
  1232. KA    Ad ProfitB
  1233. YesfH
  1234. Company
  1235. Ad Profit as of //
  1236. page ##
  1237.  ads sold.
  1238. Sales
  1239. Payment
  1240. E    Prod
  1241. Salesp Comp
  1242. Profit
  1243. % Profit
  1244. Lawrence of HollywoodB
  1245. 1/17/93D
  1246. Full page colorE
  1247. Auto SalesF
  1248. 712.5J
  1249. Frank JonesQ
  1250. 123 Santa Monica Blvd.R    HollywoodS
  1251. 90038Z
  1252. Harry]
  1253. Auto Repair^
  1254. None_
  1255. Camera Ready - approved`
  1256. Fulla
  1257. nonei
  1258. 5% Fullr
  1259. 37.5~
  1260. Kneeds
  1261. 712.50
  1262. 6/1/93
  1263. 712.5
  1264. Harry Kneeds
  1265. (213)643-3247
  1266. (213)685-1108
  1267. Not Received
  1268. Lawrence of Hollywood
  1269. Discount
  1270. Ad Manager
  1271. 712.5
  1272. 106.875
  1273. 712.5
  1274. Fall '93
  1275. Frank Jones
  1276. Automotive
  1277. 106.875
  1278. Auto Repair
  1279. Lawrence of Hollywood
  1280. Frank Jones
  1281. 06/01/93
  1282. 712.5
  1283. 106.875
  1284. 605.625
  1285. Casting for CastingB
  1286. 2/17/93D
  1287. Full page colorE
  1288. CastingF
  1289. Jerry JeepersQ
  1290. 9561 Sunset Blvd.
  1291. Suite 100R    HollywoodS
  1292. 90038Z
  1293. Andrea^
  1294. None_#To be Produced - received - Problem`
  1295. Two-Paya
  1296. nonej
  1297. Phone Number Incorrectk
  1298. 2/12/93r
  1299. Smothers
  1300. 07/17/93
  1301. Andrea Smothers
  1302. (213)453-1554
  1303. 2/18/93
  1304. 3/18/93
  1305. 07/17/93
  1306. Not Received
  1307. Casting for Casting
  1308. d    President
  1309. 1/3/93
  1310. Fall '93
  1311. 112.5
  1312. Jerry Jeepers
  1313. Entertainment
  1314. Entertainment
  1315. Casting for Casting
  1316. Jerry Jeepers
  1317. 6/17/93
  1318. A    Drew ArtsB
  1319. 1/17/93D
  1320. Full page colorE
  1321. 637.5J
  1322. Jerry Jeepers
  1323. 532 Wilshire Blvd.
  1324. Suite 230R
  1325. Beverly HillsS
  1326. 90210Z
  1327. Biff]
  1328. Creative Supplies^
  1329. None_
  1330. Old Ad - requested - OK`
  1331. Visa/MCa
  1332. Joe's Ad Agencyb 1760 Rocky Road Dr.
  1333. LA, CA 90016e
  1334. (310) 662-1233f
  1335. Tommy Smithi
  1336. 15% Agencyr
  1337. 112.5~
  1338. Jones
  1339. 137.5
  1340. 1/18/93
  1341. Biff Jones
  1342. (213)754-9890
  1343. (213)685-1108
  1344. 137.5
  1345. 137.50
  1346. 5/5/93
  1347. 6/5/93
  1348. Rcvd Contract
  1349. b    Drew Arts
  1350. Discount
  1351. Chiropactor
  1352. 637.5
  1353. Fall '93
  1354. 20.625
  1355. Jerry Jeepers
  1356. .117647058823529412
  1357. Entertainment
  1358.     Drew Arts
  1359. 137.5
  1360. Jerry Jeepers
  1361. 01/18/93
  1362. Chariots of StoneB
  1363. 3/17/93D
  1364. Quarter page (vert)E
  1365. (none)F
  1366. Jerry JeepersQ
  1367. 865 Melrose Avenue #107R    HollywoodS
  1368. 90038^
  1369. Four Color_
  1370. On Hold`
  1371. Two-Paya
  1372. noner
  1373. 3/17/83
  1374. 4/17/93
  1375. (213)658-8866
  1376. (213)213-3435
  1377. Rcvd Contract
  1378. Chariots of Stone
  1379. Owner
  1380. Fall '93
  1381. Jerry Jeepers
  1382. Allison Smothers
  1383. Entertainment
  1384. Entertainment
  1385. Chariots of Stone
  1386. Not in Furniture Section
  1387. Jerry Jeepers
  1388. Allison Smothers
  1389. 04/17/93
  1390. The ParkB
  1391. 1/11/93D
  1392. Half page (vert)E
  1393. RecreationF
  1394. Allison SmothersQ
  1395. 862 Park AvenueR
  1396. New York CityS
  1397. 10022]    Gardening
  1398. 1 spot_
  1399. Cancelled                `
  1400. Fulla
  1401. nonei
  1402. 5% Fullr
  1403. (212)467-3000
  1404. N(Spoke with Tom - said will pay this week
  1405. 3/25/93
  1406. 1/1/93
  1407. 3/11/93
  1408. 2/11/93
  1409. Rcvd Contract
  1410. The Park
  1411. Discount
  1412. Fall '93
  1413. 71.25
  1414. Allison Smothers
  1415. Entertainment
  1416. Recreation
  1417. The Park
  1418. Center Column
  1419. Allison Smothers
  1420. Grace's LemonsB
  1421. 5/2/93D
  1422. Eighth pageE
  1423. Frank JonesQ
  1424. 895 N. Canon DriveR
  1425. Beverly HillsS
  1426. 90210]
  1427. Fruit, Restaurant^
  1428. None_#To be Produced - received - Problem`
  1429. Two-Paya
  1430. nonei
  1431. Barterr
  1432. (213)471-2879
  1433. (213)685-1108
  1434. Trade for Lemons
  1435. Rcvd Contract
  1436. Grace's Lemons
  1437. Discount
  1438. Agent
  1439. 1/3/93
  1440. Fall '93
  1441. Frank Jones
  1442. Restauarant
  1443. Restaurant
  1444. Grace's Lemons
  1445. Frank Jones
  1446. Knighted KneeonsB
  1447. 1/17/93D
  1448. Tab (bleed)E
  1449. LightingF
  1450. 1000H
  1451. 1000J
  1452. Jerry JeepersQ
  1453. 45634 Varna AvenueR
  1454. North HollywoodS
  1455. 91605Z
  1456. Patty]
  1457. Advertising^
  1458. Four Color_
  1459. To be Produced - out to proof`
  1460. Two-Paya
  1461. noner
  1462. 1000z
  1463. Smith
  1464. 3/3/93
  1465. Patty Smith
  1466. (818)564-3592
  1467. 4/1/93
  1468. 5/1/93
  1469. Rcvd Contract
  1470. Knighted Kneeons
  1471. 1/3/93
  1472. Fall '93
  1473. Jerry Jeepers
  1474. Business
  1475. Business
  1476. Knighted Kneeons
  1477. Jerry Jeepers
  1478. 03/03/93
  1479. Restaurante PantineneB
  1480. 6/1/93D
  1481. Tab (non-bleed)E
  1482. (none)F
  1483. 1100J
  1484. Jerry JeepersQ
  1485. 67455 Melrose Blvd.R    HollywoodS
  1486. 90038^
  1487. Four Color_
  1488. To be Produced - out to proof`
  1489. Visa/MCa
  1490. noner
  1491. 1100z
  1492. (213)685-1108
  1493. (213)685-1108
  1494. 5/5/93
  1495. 7/5/93
  1496. 6/5/93
  1497. Rcvd Contract
  1498. Restaurante Pantinene
  1499. Adv. Manager
  1500. 3/1/93
  1501. Fall '93
  1502. Jerry Jeepers
  1503. Take Out
  1504. Restaurante Pantinene
  1505. Jerry Jeepers
  1506. Sler Vales, Inc.B
  1507. 3/17/93D
  1508. Quarter page (vert)E
  1509. AdvertisingF
  1510. Dayna LongeQ
  1511. 960 N. Lake StreetR
  1512. BurbankS
  1513. 91502Z
  1514. Tom]    Creative ^
  1515. 1 spot_
  1516. Camera Ready - approved`
  1517. Fulla
  1518. nonei
  1519. 5% Fullr
  1520. 2/1/93
  1521. Tom Fred
  1522. (818)342-4838
  1523. (818) 574-9542
  1524. Rcvd Contract
  1525. Sler Vales, Inc.
  1526. Discount
  1527. 42.75
  1528. Fall '93
  1529. Dayna Longe
  1530. Dayna Longe
  1531. Entertainment
  1532. 42.75
  1533. Advertising
  1534. Creative
  1535. Sler Vales, Inc.
  1536. Facing page to Knighted Kneeons
  1537. Dayna Longe
  1538. Dayna Longe
  1539. 02/01/93
  1540. 116.25
  1541. 168.75
  1542. .592105263157894737
  1543. A    Spot/DotyB
  1544. 6/6/93D
  1545. Quarter page (horiz)E
  1546. ClothingF
  1547. Allison SmothersQ
  1548. 290 Wilshire BlvdR
  1549. Los AngelesS
  1550. 90024Z
  1551. Fashion, Attire^
  1552. Four Color_
  1553. Camera Ready - not received`
  1554. Pay on Printa
  1555. noner
  1556. Thomas
  1557. 07/17/93
  1558. Joe Thomas
  1559. (310) 508-2134
  1560. 5/5/93
  1561. 6/25/93
  1562. 6/5/93
  1563. 07/17/93
  1564. Not Received
  1565. b    Spot/Doty
  1566. Fall '93
  1567. Allison Smothers
  1568. Personal
  1569. Fashion
  1570. Attire
  1571.     Spot/Doty
  1572. Allison Smothers
  1573. 6/17/93
  1574. Women's Happiness ClinicB
  1575. 2/6/93D
  1576. Full page colorE
  1577. MedicalF
  1578. Dayna LongeQ    31 W. 3rdR
  1579. Los AngelesS
  1580. 90048Z
  1581. Jeff]
  1582. Health, Women^
  1583. Four Color_
  1584. Old Ad - requested - Problem`
  1585. Two-Paya
  1586. nonej
  1587. Change area code 213->310k
  1588. 2/1/93r
  1589. Thomas
  1590. 07/17/93
  1591. Jeff Thomas
  1592. (213) 743-3000
  1593. 5/5/93
  1594. 6/5/93
  1595. 07/17/93
  1596. Rcvd Contract
  1597. Women's Happiness Clinic
  1598. Fall '93
  1599. 112.5
  1600. Dayna Longe
  1601. Medical
  1602. Health
  1603. Women's Happiness Clinic
  1604. Bottom Left
  1605. Dayna Longe
  1606. 6/17/93
  1607. Pasta LotsaB
  1608. 2/6/93D
  1609. Half page (horiz)E
  1610. RestaurantF
  1611. Sally SmithQ
  1612. 0875 Hillhurst AvenueR
  1613. Los AngelesS
  1614. 90027Z
  1615. Stephen]
  1616. Health^
  1617. None_
  1618. To be Produced - approved`
  1619. Fulla
  1620. nonei
  1621. 5% Fullj!Proof Approved by Angela (verbal)k
  1622. 6/1/93r
  1623. Smothers
  1624. 07/17/93
  1625. Stephen Smothers
  1626. (213)643-0458
  1627. 5/5/93
  1628. 6/5/93
  1629. 07/17/93
  1630. Rcvd Contract
  1631. Pasta Lotsa
  1632. Discount
  1633. 3/1/93
  1634. Fall '93
  1635. 71.25
  1636. Sally Smith
  1637. Take Out
  1638. Health
  1639. Pasta Lotsa
  1640. Sally Smith
  1641. 6/17/93
  1642. Films on Film & VideoB
  1643. 1/17/93D
  1644. Full page B&WE
  1645. FilmF
  1646. Frank JonesQ
  1647. 834 Sunset Blvd.R    Hollywood
  1648. 90028Z
  1649. Video, Entertainment, Movies^
  1650. 2 spot_#To be Produced - received - Problem`
  1651. Visa/MCa
  1652. Ultimate Adsb#123941 Helterberg St.
  1653. NY, NY 010231e
  1654. (315)323-2342f
  1655. Johnnyi
  1656. 15% Agencyj"Waive Production Charge as per Tomk
  1657. 6/1/93r
  1658. Simmons
  1659. 07/17/93
  1660. Don Simmons
  1661. (213) 473-2181
  1662. (213) 437-0893
  1663. 5/5/93
  1664. 6/5/93
  1665. 07/17/93
  1666. Not Received
  1667. Films on Film & Video
  1668. Discount
  1669. d    President
  1670. 5/1/93
  1671. Fall '93
  1672. Frank Jones
  1673. Frank Jones
  1674. Entertainment
  1675. Video, Entertainment, Movies
  1676. Films on Film & Video
  1677. Upper Right
  1678. Frank Jones
  1679. Frank Jones
  1680. 6/17/93
  1681. Problem
  1682. Bill All
  1683. Rebill All
  1684. Need Bill Find
  1685. Sold from Leads
  1686.  Ad Cost Defaults
  1687.  Next Bill Defaults
  1688.  Bill This One
  1689.  Rebill This One
  1690.  Rebill This Set
  1691.  Bill This Set
  1692. Command Center
  1693. MODULES:
  1694.      leads
  1695. sales
  1696.      salespeople
  1697. REPORTS:
  1698.      sold by company
  1699.      sold by salesperson
  1700.      section/actual category
  1701.      section/desired category
  1702.      Need Bills
  1703.      outstanding accounts
  1704.      overdue accounts
  1705.      production overview
  1706.      production problems
  1707.      mailing labels
  1708. SPECIAL
  1709.      calculate comissions
  1710.      comission sales reports
  1711.      Ad Profits
  1712.      salesperson sold detail
  1713.      splits by salesperson
  1714.      categories detail
  1715.      production detail
  1716.      desired categories detail
  1717.      actual categories detail
  1718. Print these Records
  1719. Print Two of This Record
  1720. Resore Page Setup
  1721. Print All Up
  1722. Rebill This Set
  1723. Rebill set pt2
  1724. Main Exports
  1725. Split Exports
  1726. startup
  1727. Print these Records
  1728. Print Two of This Record
  1729.  Bill This One
  1730.  Next Bill Defaults
  1731.  Ad Cost Defaults
  1732. Resore Page Setup
  1733.      sold by company
  1734. Print All Up
  1735.      salesperson sold detail
  1736.      categories detail
  1737.  Rebill This One
  1738. Rebill This Set
  1739. Rebill set pt2
  1740.      splits by salesperson
  1741. WIF 93
  1742. Main Exports
  1743. tempmain temp! 
  1744. lookdrct.FMct Lookupsy:
  1745. lookdrct.FMct Lookups
  1746. Split Exports
  1747. tempmain temp! 
  1748. looksplit.FM Lookupssy:
  1749. looksplit.FM Lookupss
  1750.      calculate comissions
  1751. Salespeople.FM 
  1752. Specify:
  1753. lookdrct.FMcalculat
  1754. looksplit.FMalculat
  1755. sales
  1756.      salespeople
  1757. Salespeople.FMP
  1758.      leads
  1759. Leads.FM
  1760. Sold from Leads
  1761. MODULES:
  1762. REPORTS:
  1763. SPECIAL
  1764.      desired categories detail
  1765.      actual categories detail
  1766.      section/actual category
  1767.      production overview
  1768.      production detail
  1769.      sold by salesperson
  1770.      outstanding accounts
  1771.      mailing labels
  1772.      production problems
  1773. Problem
  1774.      section/desired category
  1775.      overdue accounts
  1776. Rebill All
  1777.  Rebill This Set
  1778. Need Bill Find
  1779. <=6/5/93
  1780.      Need Bills
  1781. Bill All
  1782.  Bill This Set
  1783.      comission sales reports
  1784.      Ad Profits
  1785. Command Center
  1786. AdMaster.FM
  1787. startup
  1788. Test Group
  1789.     Helvetica
  1790. Geneva
  1791. Chicago
  1792. New York
  1793. Palatino
  1794. Avant Garde
  1795. N Helvetica Narrow
  1796. Times
  1797. User Dictionary
  1798.